<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Filtering data based on metrics</title>
<link rel="stylesheet" href="RoboHTML_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='RoboHTML.css'>");}
//-->
</script>
<style type="text/css">
<!--
img_whs1 { border:none; width:17px; height:17px; float:none; border-style:none; }
-->
</style><script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Analyzing report and document results\nRestricting report results: Filtering\nFiltering data based on metrics");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Filtering data based on metrics</h1>
<p>Using view filters based on metrics, you can view a subset of report 
 data that focuses on the data values and ranges you are interested in. 
 Narrowing the focus of a report to the data that is of interest of you 
 enables another level of report analysis that can highlight business trends 
 and figures. </p>
<p>When creating metric qualifications in a view filter, you can use various 
 logical and mathematical operators. You can use any of the following operators 
 in metric qualifications. See the <span style="font-style: italic;"><I>MicroStrategy 
 Advanced Reporting Guide </I></span><span>for more information. </span></p>
<ul>
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>Equals</p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>Does not 
 equal</p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>Greater 
 than</p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>Greater 
 than or equal to</p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>Less than</p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>Less than 
 or equal to</p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>Between 
 (enter value1;value2)</p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>Not Between 
 (enter value1;value2)</p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>Is Null</p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>Is Not 
 Null</p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>In (enter 
 value 1;value 2;. . .;valueN)</p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>Not In 
 (enter value1;value2; . . .;valueN)</p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>Highest</p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>Lowest</p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>Highest 
 (%)</p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>Lowest 
 (%)</p></li>
</ul>
<p>Once you select an operator, you can either type in a value or select 
 a metric to return the value to qualify on.</p>
<p>The steps below show you how to create a view filter with a metric qualification, 
 as well as how the example scenario above was created.</p>
<h2>Prerequisites</h2>
<ul>
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>You need 
 the Web Use View Filter Editor privilege. This privilege is part of OLAP 
 Services.</p></li>
</ul>
<h2>To create a view filter with a metric qualification</h2>
<ol>
<li class=p-Steps><p class=Steps>Log into a project in MicroStrategy 
 Web. </p></li>
	
<li class=p-Steps><p class=Steps>Run the report in Grid View. </p></li>
	
<li class=p-Steps><p class=Steps>If the View Filter area is not displayed, 
 from the<span style="font-weight: bold;"><B> Tools</B></span> menu, select <span 
 style="font-weight: bold;"><B>View Filter</B></span>. </p></li>
	
<li class=p-Steps><p class=Steps>In Web, in the <span style="font-weight: bold;"><B>View 
 Filter</B></span> area, click <span style="font-weight: bold;"><B>Add Condition</B></span>.</p></li>
	
<li class=p-Steps><p class=Steps>From the<span style="font-weight: bold;"><B> 
 Filter On </B></span>drop-down list, select a metric.</p></li>
	
<li class=p-Steps><p class=Steps>Select an operator from the drop-down 
 list and type a value. </p></li>
	<ul>
<li class=P-Steps-Bulleted-1><p class=Steps-Bulleted-1>To compare 
 the metric to another metric, click the <span style="font-weight: bold;"><B>Select</B></span> 
 <span style="font-weight: bold;"><B>Metric</B></span> icon <img src="images/viewfilterattribute.gif" x-maintain-ratio="TRUE" width="17px" height="17px" border="0" class="img_whs1">. Then select another metric to compare it 
 to. Selecting a metric allows you to create a metric-to-metric qualification, 
 which are described in 
<a href="Filtering_on_metric-to-metric_comparisons.htm">Filtering 
 on metric-to-metric comparisons</a>.</p></li>
	</ul>
</ol>
<ol start=7>
<li class=p-Steps><p class=Steps>Click <span style="font-weight: bold;"><B>Apply</B></span> 
 icon <img src="images/apply.gif" x-maintain-ratio="TRUE" width="17px" height="17px" border="0" class="img_whs1"> to complete the view filter qualification.</p></li>
	
<li class=p-Steps><p class=Steps>If the <span style="font-weight: bold;"><B>Auto-Apply 
 Changes</B></span> check box is cleared, click <span style="font-weight: bold;"><B>Apply</B></span> 
 to apply the view filter to the report. </p></li>
</ol>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
